CREATE TABLE jms_dm.dm_customer_reback_net_detail_dt (
  waybill_no            varchar(50)     null COMMENT '单号'
  ,date_time            date         null COMMENT '申请时间'
  ,sender_network_name    varchar(200) null COMMENT '寄件(揽收)网点名称'
  ,sender_network_code    varchar(200) null COMMENT '寄件(揽收)网点code'
  ,customer_code        varchar(200) null COMMENT '客户code'
  ,customer_name        varchar(200) null COMMENT '客户名称'
  ,apply_type_name        varchar(20)     null COMMENT '退回类型默认：退回'
) ENGINE=OLAP
DUPLICATE KEY(`waybill_no`)
COMMENT "退回件明细"
PARTITION BY RANGE(`date_time`)
(START ('2023-03-01') END ('2023-04-20') EVERY (INTERVAL 1 day) )
DISTRIBUTED BY HASH(`waybill_no`) BUCKETS 10
PROPERTIES (
"replication_num" = "3",
"bloom_filter_columns" = "waybill_no",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-35",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "10",
"in_memory" = "false",
"storage_format" = "V2"
);